﻿<?xml version="1.0" encoding="utf-8" ?>
<DbDataRequest connection="$ForumDBConnection$" type="$ForumDBType$" defaultFormatter="bizobj Forum(lastPost(createdBy))">
  <SqlStatement hasResults="true">
    SELECT 
      id, name, description, forumImageUrl,forumGroupId,
      lastPostById as createdByid,
      lastPostByName as createdByuserName,
      lastPostDate as lastPostdateCreated,
      lastPostTitle as lastPosttitle,
      numPost as numPosts,numThread as numThreads
   FROM Forum WHERE forumGroupId=@forumGroupId
  </SqlStatement>
  <Param name="forumGroupId" type="UniqueIdentifier" />
</DbDataRequest>
